[dbo].[Name_Indexes]

Property	Value
Created	3:12:43 PM Friday, January 07, 2011
Last Modified	11:40:04 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
	ID	varchar(10)	10	('')
$Cluster Key iName_IndexesINDEX_NAME: INDEX_NAME\INDEX_VALUE$	INDEX_NAME	varchar(31)	31	('')
$Cluster Key iName_IndexesINDEX_NAME: INDEX_NAME\INDEX_VALUE$	INDEX_VALUE	varchar(30)	30	('')
	QUANTITY	int	4	((0))
	TIME_STAMP	timestamp	8

	Name	Columns
	iName_IndexesID	ID
$Cluster Key iName_IndexesINDEX_NAME: INDEX_NAME\INDEX_VALUE$	iName_IndexesINDEX_NAME	INDEX_NAME, INDEX_VALUE

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Name_Indexes]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Indexes_ID] DEFAULT (''),
[INDEX_NAME] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Indexes_INDEX_NAME] DEFAULT (''),
[INDEX_VALUE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Name_Indexes_INDEX_VALUE] DEFAULT (''),
[QUANTITY] [int] NOT NULL CONSTRAINT [DF_Name_Indexes_QUANTITY] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iName_IndexesID] ON [dbo].[Name_Indexes] ([ID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iName_IndexesINDEX_NAME] ON [dbo].[Name_Indexes] ([INDEX_NAME], [INDEX_VALUE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Name_Indexes] TO [IMIS]
GRANT SELECT ON  [dbo].[Name_Indexes] TO [IMIS]
GRANT INSERT ON  [dbo].[Name_Indexes] TO [IMIS]
GRANT DELETE ON  [dbo].[Name_Indexes] TO [IMIS]
GRANT UPDATE ON  [dbo].[Name_Indexes] TO [IMIS]
GO